/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_sys_cfg_tree.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_SYS_CFG_TREE
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_sys_cfg_tree.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "table_ppm.h"

CTable_SYS_CFG_TREE::CTable_SYS_CFG_TREE( )
 :NPCRecordSet( )
{
  setTableName( "SYS_CFG_TREE" );
  prepareTable();
  prepareQuery();
 
  REMARKS.setField( "REMARKS", DATA_CHAR, 512, 0 );
  makeTableItem( REMARKS );
  SYS_ID.setField( "SYS_ID", DATA_CHAR, 40, 0 );
  makeTableItem( SYS_ID );
  STATE.setField( "STATE", DATA_CHAR, 20, 0 );
  makeTableItem( STATE );
  ID.setField( "ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( ID );
  makeKeyItem( ID ); 
  CFG_NAME.setField( "CFG_NAME", DATA_CHAR, 512, 0 );
  makeTableItem( CFG_NAME );
  CFG_CODE.setField( "CFG_CODE", DATA_CHAR, 512, 0 );
  makeTableItem( CFG_CODE );
  CFG_TYPE.setField( "CFG_TYPE", DATA_CHAR, 10, 0 );
  makeTableItem( CFG_TYPE );
  PARENT_ID.setField( "PARENT_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( PARENT_ID );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
  MODIFY_DATE.setField( "MODIFY_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( MODIFY_DATE );
}


CTable_SYS_CFG_TREE::CTable_SYS_CFG_TREE( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "SYS_CFG_TREE" );
  prepareTable();
  prepareQuery();
 
  REMARKS.setField( "REMARKS", DATA_CHAR, 512, 0 );
  makeTableItem( REMARKS );
  SYS_ID.setField( "SYS_ID", DATA_CHAR, 40, 0 );
  makeTableItem( SYS_ID );
  STATE.setField( "STATE", DATA_CHAR, 20, 0 );
  makeTableItem( STATE );
  ID.setField( "ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( ID );
  makeKeyItem( ID ); 
  CFG_NAME.setField( "CFG_NAME", DATA_CHAR, 512, 0 );
  makeTableItem( CFG_NAME );
  CFG_CODE.setField( "CFG_CODE", DATA_CHAR, 512, 0 );
  makeTableItem( CFG_CODE );
  CFG_TYPE.setField( "CFG_TYPE", DATA_CHAR, 10, 0 );
  makeTableItem( CFG_TYPE );
  PARENT_ID.setField( "PARENT_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( PARENT_ID );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
  MODIFY_DATE.setField( "MODIFY_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( MODIFY_DATE );
}

CTable_SYS_CFG_TREE::~CTable_SYS_CFG_TREE( )
{
    close();
}

